﻿<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="view_list_guest.aspx.cs" Inherits="view_list_guest" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    
    <div align="center">
    <br /><br /><br /><img src="Image/view-list-guest.png" alt=""/>
    <br /><br />
    
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
            DataKeyNames="GUEST_ID" DataSourceID="orclDataSource1" AllowPaging="True" 
            AllowSorting="True" ForeColor="#FFCC66" BorderColor="#4A1106" 
            PageSize="20" >
            <Columns>
                <asp:BoundField DataField="GUEST_ID" HeaderText="GUEST_ID" ReadOnly="True" 
                    SortExpression="GUEST_ID" />
                <asp:BoundField DataField="PRENAME" HeaderText="PRENAME" 
                    SortExpression="PRENAME" />
                <asp:BoundField DataField="GUEST_FNAME" HeaderText="FIRSTNAME" 
                    SortExpression="GUEST_FNAME" />
                <asp:BoundField DataField="GUEST_LNAME" HeaderText="LASTNAME" 
                    SortExpression="GUEST_LNAME" />
                <asp:BoundField DataField="ADDRESS" HeaderText="ADDRESS" 
                    SortExpression="ADDRESS" >
                <ItemStyle Font-Overline="False" Width="200px" Wrap="False" />
                </asp:BoundField>
                <asp:BoundField DataField="GUEST_TEL" HeaderText="TEL No." 
                    SortExpression="GUEST_TEL" />
                <asp:BoundField DataField="GUEST_TYPE_NAME" HeaderText="GUEST TYPE" 
                    SortExpression="GUEST_TYPE_NAME" />
                <asp:BoundField DataField="DISCOUNT" HeaderText="%" 
                    SortExpression="DISCOUNT" />
            </Columns>
            <HeaderStyle BackColor="#993300" />
            <PagerStyle HorizontalAlign="Center" />
            <RowStyle HorizontalAlign="Center" />
        </asp:GridView>
        <asp:SqlDataSource ID="orclDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString9 %>" 
            ProviderName="<%$ ConnectionStrings:ConnectionString9.ProviderName %>" 
            SelectCommand="SELECT GUESTS.GUEST_ID, GUESTS.GUEST_FNAME, GUESTS.GUEST_LNAME, GUESTS.ADDRESS, GUESTS.GUEST_TEL, GUEST_TYPE.GUEST_TYPE_NAME, GUEST_TYPE.DISCOUNT, PRENAMES.PRENAME FROM GUESTS INNER JOIN GUEST_TYPE ON GUESTS.GUEST_TYPE_ID = GUEST_TYPE.GUEST_TYPE_ID INNER JOIN PRENAMES ON GUESTS.PRENAME_ID = PRENAMES.PRENAME_ID">
        </asp:SqlDataSource>
            <asp:Button ID="Button5" runat="server" BackColor="#FFCC66" 
                BorderColor="#FF9966" Height="25px" onclick="Back_Click" Text="&lt;&lt; Back" 
                Width="85px" />
    <br /><br /><br />
    </div>
</asp:Content>

